Answers for Data Warehousing Online Test | Mock Test
←Go Back to Online Practice Test| Ques. Sequence of jobs to load data in to warehouse |
| Option 1. First load data into fact tables then dimension tables, then Aggregates if any |
| Option 2. First load data into dimension tables, then fact tables, then Aggregates if any |
| Option 3. First Aggregates then load data into dimension tables, then fact tables |
| Option 4. Does not matter if we load either of fact, dimensions, or aggregates |
Ans. Option 2 |
| Please provide the reason below. The best provided reason will be displayed with your name(if you are logged-in) on website. |
| Enter Reason |
Is it helpful?
Yes
No